9039cca3bca28392cb227e7c53fde94c026f50c0,portal-impl/src/com/liferay/portal/upgrade/v5_3_0/UpgradePolls.java,UpgradePolls,doUpgrade,#,38
Before Change
protected void doUpgrade() throws Exception {
if (isSupportsAlterColumnType()) {
runSQL("alter_column_type PollsChoice description STRING null");
runSQL("alter_column_type PollsQuestion title STRING null");
}
else {
// PollsChoice
UpgradeTable upgradeTable = new DefaultUpgradeTableImpl(
PollsChoiceTable.TABLE_NAME, PollsChoiceTable.TABLE_COLUMNS);
upgradeTable.setCreateSQL(PollsChoiceTable.TABLE_SQL_CREATE);
upgradeTable.updateTable();
// PollsQuestion
upgradeTable = new DefaultUpgradeTableImpl(
PollsQuestionTable.TABLE_NAME,
PollsQuestionTable.TABLE_COLUMNS);
upgradeTable.setCreateSQL(PollsQuestionTable.TABLE_SQL_CREATE);
upgradeTable.updateTable();
}
}
After Change
upgradeTable.updateTable();
}
try {
runSQL("alter_column_type PollsQuestion title STRING null");
}
catch (Exception e) {
// PollsQuestion
UpgradeTable upgradeTable = new DefaultUpgradeTableImpl(
PollsQuestionTable.TABLE_NAME,
PollsQuestionTable.TABLE_COLUMNS);
upgradeTable.setCreateSQL(PollsQuestionTable.TABLE_SQL_CREATE);
upgradeTable.updateTable();
}
}